package DBLayer;
import java.sql.SQLException;
import java.util.ArrayList;

import ModelLayer.Supplier;

public interface IFDBSupplier {
		//get all Suppliers
		public ArrayList<Supplier> getAllSupplier();
		//get one Supplier having the cvr
	    public Supplier findSupplier(String cvr);
	    //find one Supplier having the cvr
	    public Supplier searchSupplierCvr(String cvr);
	    //find one Supplier having the name
	    public Supplier searchSupplierName(String sName);
	    //find one Supplier having the phoneNo
	    public Supplier searchSupplierSPhoneNo(int sPhoneNo);
	    //find one Supplier having the email
	    public Supplier searchSupplierEmail(String email);
	    //insert a new Supplier
	    public void insertSupplier(Supplier supplier) throws SQLException;
	    //update information about Supplier
	    public void updateSupplier(Supplier supplier) throws SQLException;
	    //rid of supplier
	    public void deleteSupplier(Supplier supplier) throws SQLException;
}
